create external table jms_dm.dm_center_transfer_summary_dt(
  scan_time            string        comment '扫描时间',
  scan_site_code       string        comment '中心code',
  scan_site_name       string        comment '中心名称',
  provider_id          string        comment '省份id',
  provider_desc        string        comment '省份名称',
  city_id              string        comment '城市id',
  city_desc            string        comment '城市名称',
  regional_id          string        comment '大区id',
  regional_desc        string        comment '大区名称',
  agent_code           string        comment '代理区code',
  agent_name           string        comment '代理区名称',
  order_source_code    string        comment '订单来源code',
  order_source_name    string        comment '订单来源名称',
  oper_shift           string        comment '操作班次',
  arrival_cnt          bigint        comment '到件量',
  send_cnt             bigint        comment '发件量',
  arrival_pack_cnt     bigint        comment '到包量',
  send_pack_cnt        bigint        comment '发包量',
  enterport_cnt        bigint        comment '进港件量汇总',
  same_city_cnt        bigint        comment '同城件量汇总',
  transfer_cnt         bigint        comment '中转件量汇总',
  leaveport_cnt        bigint        comment '出港件量汇总',
  enterport_pack_cnt   bigint        comment '进港包量汇总',
  same_city_pack_cnt   bigint        comment '同城包量汇总',
  transfer_pack_cnt    bigint        comment '中转包量汇总',
  leaveport_pack_cnt   bigint        comment '出港包量汇总',
  enterport_weight_tot decimal(15,2) comment '进港重量汇总',
  same_city_weight_tot decimal(15,2) comment '同城重量汇总',
  transfer_weight_tot  decimal(15,2) comment '中转重量汇总',
  leaveport_weight_tot decimal(15,2) comment '出港重量汇总',
  trans_cnt            bigint        comment '转运货量/件',
  trans_pack_cnt       bigint        comment '转运货量/包',
  oper_cnt             bigint        comment '操作件量',
  oper_pack_cnt        bigint        comment '操作包量',
  oper_weight_tot      decimal(15,2) comment '操作重量汇总',
  other_cnt            bigint        comment '其他件量',
  other_pack_cnt       bigint        comment '其他包量',
  other_weight_tot     decimal(15,2) comment '其他重量',
  sys_time             string        comment '跑批时间',
  effect_start_time    string        comment '生效开始时间',
  effect_end_time      string        comment '生效结束时间',
  shift_start_time     string        comment '班次开始时间',
  shift_end_time       string        comment '班次结束时间',
  sum_flag             string        comment '汇总类型 班次日、自然日'
)
comment '中转进出港分析天汇总表-天'
partitioned by ( dt string comment '日期')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_center_transfer_summary_dt'
tblproperties (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
    );